// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   register_draft_ok.java

package qcs.crm_deliver;

import com.jspsmart.upload.*;
import include.nseer_cookie.*;
import include.nseer_db.nseer_db_backup1;
import java.io.IOException;
import java.net.URL;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;

public class register_draft_ok extends HttpServlet
{

	public register_draft_ok()
	{
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			ServletContext context = session.getServletContext();
			String path = context.getRealPath("/");
			counter count = new counter(dbApplication);
			SmartUpload mySmartUpload = new SmartUpload();
			mySmartUpload.setCharset("UTF-8");
			nseer_db_backup1 qcs_db = new nseer_db_backup1(dbApplication);
			if (qcs_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				mySmartUpload.initialize(pageContext);
				String file_type = getFileLength.getFileType((String)session.getAttribute("unit_db_name"));
				long d = getFileLength.getFileLength((String)session.getAttribute("unit_db_name"));
				mySmartUpload.setMaxFileSize(d);
				mySmartUpload.setAllowedFilesList(file_type);
				try
				{
					mySmartUpload.upload();
					String item[] = mySmartUpload.getRequest().getParameterValues("item");
					if (item != null)
					{
						String file_name[] = new String[mySmartUpload.getFiles().getCount()];
						Date now = new Date();
						SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
						String time = formatter.format(now);
						String qcs_id = NseerId.getId(getClass().getResource("").toString(), (String)dbSession.getAttribute("unit_db_name"));
						for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++)
						{
							SmartFile file = mySmartUpload.getFiles().getFile(i);
							if (file.isMissing())
							{
								file_name[i] = "";
							} else
							{
								int filenum1 = count.read((String)dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount");
								count.write((String)dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount", filenum1);
								file_name[i] = (new StringBuilder(String.valueOf(filenum1))).append(file.getFileName()).toString();
								file.saveAs((new StringBuilder(String.valueOf(path))).append("qcs/file_attachments/").append(filenum1).append(file.getFileName()).toString());
							}
						}

						String apply_id = mySmartUpload.getRequest().getParameter("apply_id");
						String stock_name = mySmartUpload.getRequest().getParameter("stock_name");
						String stock_id = mySmartUpload.getRequest().getParameter("stock_id");
						String product_id = mySmartUpload.getRequest().getParameter("product_id");
						String product_name = mySmartUpload.getRequest().getParameter("product_name");
						String qcs_amount = mySmartUpload.getRequest().getParameter("qcs_amount");
						String qcs_time = mySmartUpload.getRequest().getParameter("qcs_time");
						String quality_way = mySmartUpload.getRequest().getParameter("quality_way");
						String quality_solution = mySmartUpload.getRequest().getParameter("quality_solution");
						String sampling_standard = mySmartUpload.getRequest().getParameter("sampling_standard");
						String sampling_amount = mySmartUpload.getRequest().getParameter("sampling_amount");
						String accept = mySmartUpload.getRequest().getParameter("accept");
						String reject = mySmartUpload.getRequest().getParameter("reject");
						String qualified = mySmartUpload.getRequest().getParameter("qualified");
						String unqualified = mySmartUpload.getRequest().getParameter("unqualified");
						String qcs_result = mySmartUpload.getRequest().getParameter("qcs_result");
						String register = mySmartUpload.getRequest().getParameter("register");
						String register_time = mySmartUpload.getRequest().getParameter("register_time");
						String bodyab = new String(mySmartUpload.getRequest().getParameter("remark").getBytes("UTF-8"), "UTF-8");
						String remark = exchange.toHtml(bodyab);
						String sqla = "insert into qcs_crm_deliver(qcs_id,stock_id,stock_name,apply_id,product_id,product_name,qcs_amount,qcs_time,quality_way,quality_solution,sampling_standard,sampling_amount,accept,reject,qualified,unqualified,qcs_result,register,register_time,remark,check_tag";
						String sqlb = (new StringBuilder(") values ('")).append(qcs_id).append("','").append(stock_id).append("','").append(stock_name).append("','").append(apply_id).append("','").append(product_id).append("','").append(product_name).append("','").append(qcs_amount).append("','").append(qcs_time).append("','").append(quality_way).append("','").append(quality_solution).append("','").append(sampling_standard).append("','").append(sampling_amount).append("','").append(accept).append("','").append(reject).append("','").append(qualified).append("','").append(unqualified).append("','").append(qcs_result).append("','").append(register).append("','").append(register_time).append("','").append(remark).append("','5'").toString();
						for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++)
						{
							int p = i + 1;
							sqla = (new StringBuilder(String.valueOf(sqla))).append(",attachment").append(p).toString();
							sqlb = (new StringBuilder(String.valueOf(sqlb))).append(",'").append(file_name[i]).append("'").toString();
						}

						String sql = (new StringBuilder(String.valueOf(sqla))).append(sqlb).append(")").toString();
						qcs_db.executeUpdate(sql);
						String default_basis[] = mySmartUpload.getRequest().getParameterValues("default_basis");
						String ready_basis[] = mySmartUpload.getRequest().getParameterValues("ready_basis");
						String quality_method[] = mySmartUpload.getRequest().getParameterValues("quality_method");
						String analyse_method[] = mySmartUpload.getRequest().getParameterValues("analyse_method");
						String standard_value[] = mySmartUpload.getRequest().getParameterValues("standard_value");
						String standard_max[] = mySmartUpload.getRequest().getParameterValues("standard_max");
						String standard_min[] = mySmartUpload.getRequest().getParameterValues("standard_min");
						String quality_value[] = mySmartUpload.getRequest().getParameterValues("quality_value");
						String sampling_amount_d[] = mySmartUpload.getRequest().getParameterValues("sampling_amount_d");
						String qualified_d[] = mySmartUpload.getRequest().getParameterValues("qualified_d");
						String unqualified_d[] = mySmartUpload.getRequest().getParameterValues("unqualified_d");
						String quality_result[] = mySmartUpload.getRequest().getParameterValues("quality_result");
						String unqualified_reason[] = mySmartUpload.getRequest().getParameterValues("unqualified_reason");
						for (int i = 0; i < item.length; i++)
						{
							if (!item[i].equals(""))
							{
								sql = (new StringBuilder("insert into qcs_crm_deliver_details(qcs_id,item,default_basis,ready_basis,quality_method,analyse_method,standard_value,standard_max,standard_min,quality_value,sampling_amount_d,qualified_d,unqualified_d,quality_result,unqualified_reason,details_number) values('")).append(qcs_id).append("','").append(item[i]).append("','").append(default_basis[i]).append("','").append(ready_basis[i]).append("','").append(quality_method[i]).append("','").append(analyse_method[i]).append("','").append(standard_value[i]).append("','").append(standard_max[i]).append("','").append(standard_min[i]).append("','").append(quality_value[i]).append("','").append(sampling_amount_d[i]).append("','").append(qualified_d[i]).append("','").append(unqualified_d[i]).append("','").append(quality_result[i]).append("','").append(unqualified_reason[i]).append("','").append(i).append("')").toString();
								qcs_db.executeUpdate(sql);
							}
							sql = (new StringBuilder("update qcs_apply_details set qcs_tag='1' where apply_id='")).append(apply_id).append("'").toString();
							qcs_db.executeUpdate(sql);
						}

						response.sendRedirect("qcs/crm_deliver/register_draft_ok.jsp?finished_tag=0");
						qcs_db.commit();
						qcs_db.close();
					} else
					{
						response.sendRedirect("qcs/crm_deliver/register_draft_ok.jsp?finished_tag=1");
					}
				}
				catch (Exception ex)
				{
					response.sendRedirect("qcs/crm_deliver/register_draft_ok.jsp?finished_tag=2");
				}
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
